UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eP3G9k7rjnflGCFnjdt1yfFYlovtWOISeBK1h0Q0JYo='
WHERE
key_id = 'd7bb28efded67b166bc0185cefc2c1e6623044a453e9dd81eece1338ff88964e'
AND (
token = 'eP3G9k7rjnflGCFnjdt1yfFYlovtWOISeBK1h0Q0JYo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)