UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hqJHlUM0q7yR28psDT6tQsl06DU1ZDldEogw7Cdlx8k='
WHERE
key_id = '6d17bf3e4408c9acd230075cc528f7f9b0f7191e27d0b38270e49db40fb1f29c'
AND (
token = 'hqJHlUM0q7yR28psDT6tQsl06DU1ZDldEogw7Cdlx8k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)