UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E49R+YmipSquRwLdv5zvLtR2l8tNzerEqSwlh8iIsBk='
WHERE
key_id = 'd5fc30dfa0b62854727ed5437bd859588bb6a5095e9735bb32ba43a8dd742ba2'
AND (
token = 'E49R+YmipSquRwLdv5zvLtR2l8tNzerEqSwlh8iIsBk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)