UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9iHZF92EtKPRx3tOE1dJ9L8G0jRUaG+78CAkWg3Sz5E='
WHERE
key_id = '5960933f5d3912ea0cd00502312154bd7bf2a7caba183d5e100b8048ddd9019c'
AND (
token = '9iHZF92EtKPRx3tOE1dJ9L8G0jRUaG+78CAkWg3Sz5E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)