UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'swmE9FYEKzl8Bxl1wInMm99uHVKOs+3/1fcbpeodlcE='
WHERE
key_id = 'c0d2ce47758443c3264b3b1c1b396ae12c25d9adc1d20e1af05e518958739df4'
AND (
token = 'swmE9FYEKzl8Bxl1wInMm99uHVKOs+3/1fcbpeodlcE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)