UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8LFYh3RBJw0nEfyKTWV8y2GNeyd7Ldn+YBl+y+XBKhg='
WHERE
key_id = '42e34a19f7541f2a99e8d9276bff529c923e21ebd39077ac67f6056257ffbb74'
AND (
token = '8LFYh3RBJw0nEfyKTWV8y2GNeyd7Ldn+YBl+y+XBKhg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)