UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '28mzKlr9Ubkt/wiQ+p173ZNwEnfhWwtqDfeaJRIX9fg='
WHERE
key_id = '0ac63f1cc40a51a036d30c568b04517ace0ee7ad5aac20e1521825f11f869cb4'
AND (
token = '28mzKlr9Ubkt/wiQ+p173ZNwEnfhWwtqDfeaJRIX9fg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)