UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oPdRayBdJEpBpwj7f5LD7CUc9gK0rJofOm8+uW/8YSE='
WHERE
key_id = 'a1edfa814fe72707c15d72d59589d5368839a6b084981120634e4560e7fea566'
AND (
token = 'oPdRayBdJEpBpwj7f5LD7CUc9gK0rJofOm8+uW/8YSE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)