UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QsTv7vagcU0s9yzBt3WoEA2KRy2+jqD1Fdp56p80HXc='
WHERE
key_id = '0045157c290ed33a4105ec9875efb38a4f167e0f9fbf72777f4291ac133924d0'
AND (
token = 'QsTv7vagcU0s9yzBt3WoEA2KRy2+jqD1Fdp56p80HXc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)