UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1rA1gPQNCc8o5c+IK7Z4JtzaPKUExj+FJ6amgC6aQxI='
WHERE
key_id = '4a64b3089e9cfc5f1670f6ccbf72f4cf948fd9b869ed71cdea804d893c21a5eb'
AND (
token = '1rA1gPQNCc8o5c+IK7Z4JtzaPKUExj+FJ6amgC6aQxI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)