UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '28LmgaBs0vb+g7QqyE89ve4L7MygbPAO22QeaY5uJj4='
WHERE
key_id = 'a87d397b66057584068b7ebe3f0472026b3349898463725b6cd832f163fbc283'
AND (
token = '28LmgaBs0vb+g7QqyE89ve4L7MygbPAO22QeaY5uJj4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)