UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+EsaadaKsICeA0kHTDHTMl4UOYNpvAhdNhJgXxFRJm0='
WHERE
key_id = 'b783817ea62a242d923c9a2f97e925779e3bd79d1dd277960d59402647e0bc5f'
AND (
token = '+EsaadaKsICeA0kHTDHTMl4UOYNpvAhdNhJgXxFRJm0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)