UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jgDDg6ap1UQksPsyOyO9ckay4g00xI3TMjnquiX03Wc='
WHERE
key_id = '847033d7f10f04c8090540fb6292eb1454aa28931762250442373119cf33c7a5'
AND (
token = 'jgDDg6ap1UQksPsyOyO9ckay4g00xI3TMjnquiX03Wc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)