UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MpW6D/IUjwGJQVHmOqLai1Uk7npnG50XV8x1bBhp6LU='
WHERE
key_id = 'cac75ad4adbdd90df59a0ef37d932870c1a5d805fab43dd53b139887739a8aca'
AND (
token = 'MpW6D/IUjwGJQVHmOqLai1Uk7npnG50XV8x1bBhp6LU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)