UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1GLIp/29Ym7Qu4TgP25uNZpvImyxi8Wkf4uoMY8F9gI='
WHERE
key_id = 'c5ed030c5f4854232af903f672d6962cef0a6977931f671c379a946c325291f8'
AND (
token = '1GLIp/29Ym7Qu4TgP25uNZpvImyxi8Wkf4uoMY8F9gI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)