UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fA4FftvHEGaMQmSit7z14RRpxxJCZrEJwGNDww2WWu4='
WHERE
key_id = '79e09fd88162cb8def0f34e6f7f223cb7f1c52deb61d8bdc93eccb3e570d1c2a'
AND (
token = 'fA4FftvHEGaMQmSit7z14RRpxxJCZrEJwGNDww2WWu4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)