UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D7dwGoFQzmwIkcOQ+3xkpnA4wKoOsnmPh0kif19LIJ8='
WHERE
key_id = '78f00396a05fb618fa4570e86a8d25e7f7622306b60096438cce44f516b61ffb'
AND (
token = 'D7dwGoFQzmwIkcOQ+3xkpnA4wKoOsnmPh0kif19LIJ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)