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