UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1J7kf94spcdDXaJWqTJFH4Ht49h8IE9Gs80eKpr6Otw='
WHERE
key_id = '7b372396a49de32e0ac1166c92bc452894e69933156e1882d7fc73b706c62526'
AND (
token = '1J7kf94spcdDXaJWqTJFH4Ht49h8IE9Gs80eKpr6Otw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)