UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j8BmqIaoMwq+I/wGBWTQtWhZ3hPDyYLHjqmOi1gm+RQ='
WHERE
key_id = 'e4ae4f5361c15b1d7d019f500c02f2f613d4338939f0decd8addf59099b05dc8'
AND (
token = 'j8BmqIaoMwq+I/wGBWTQtWhZ3hPDyYLHjqmOi1gm+RQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)