UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'twn3tPKb/x7gWBsDVz5njSrvrgUfP3HBFBI0l27OSc0='
WHERE
key_id = 'c7cc900d705319820bd0b73acd31197e3b03c41c281d0696f96bcd942723373f'
AND (
token = 'twn3tPKb/x7gWBsDVz5njSrvrgUfP3HBFBI0l27OSc0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)