UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KlmyWDcjp71olWtmXS2PYGJwu3DkhpyscEfu8XaP8O4='
WHERE
key_id = '148dc32b54330e4b35d78baff8797fb0069cd2ac83e655eba103598c5d70cca4'
AND (
token = 'KlmyWDcjp71olWtmXS2PYGJwu3DkhpyscEfu8XaP8O4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)