UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pVk8RHadFOnZ9kbyhnSdzFTFjA+bMMi35PRv1wYXoVQ='
WHERE
key_id = '99841390f4312aecbf186c75cc2457c51498067f62cc234cdb6177e2744977d0'
AND (
token = 'pVk8RHadFOnZ9kbyhnSdzFTFjA+bMMi35PRv1wYXoVQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)