UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oGm1ZE/N1urEJQ0rsqQGOFPFnyE8S5DXRMyIK6Ts+44='
WHERE
key_id = '7f9894009649e830524d2defba22052e6d64cfd502fb8d06b03c01a58cbb93b3'
AND (
token = 'oGm1ZE/N1urEJQ0rsqQGOFPFnyE8S5DXRMyIK6Ts+44='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)