UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bZWPhS503PIyBwcn4zL6xspoplronhNyiM/qilLtdmM='
WHERE
key_id = '08f759c19ad65658bf15077ede194b54d08979463f3a93baabee7f8040159ae3'
AND (
token = 'bZWPhS503PIyBwcn4zL6xspoplronhNyiM/qilLtdmM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)