UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5d4/McZgNj3xE2DzE7dN0NJbCzcAFGHSc8awccMV0oU='
WHERE
key_id = 'e2678472c35947cb9800e8150f5b5c877df7c69502993fe81adab0a459fd3365'
AND (
token = '5d4/McZgNj3xE2DzE7dN0NJbCzcAFGHSc8awccMV0oU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)