UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oimUapDdZmkv15quTv6xEpiEH4I/ZSJG0tZJ4QZukcE='
WHERE
key_id = 'b8d0765240312114b8d972df0b99cf625594b5931a94010f2071a0d9d8800b0f'
AND (
token = 'oimUapDdZmkv15quTv6xEpiEH4I/ZSJG0tZJ4QZukcE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)