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