UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6tiuNcmqFhpOR/7lDncNbGTjfjyZJpqbK/DnN0/XLnw='
WHERE
key_id = '9e9bffe54a14a43718c555654e20ad3a069884c9ce6eaf58d3c5b80b35e2ec8a'
AND (
token = '6tiuNcmqFhpOR/7lDncNbGTjfjyZJpqbK/DnN0/XLnw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)