UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VAKxpvYHzOtALFYNhRR3sSblFYnu0nY3zHBfs3ujL6o='
WHERE
key_id = '1e0327d8a08451b1161ce8bf5969de0acf9c8a187beaa5f8be73d0fb570caf06'
AND (
token = 'VAKxpvYHzOtALFYNhRR3sSblFYnu0nY3zHBfs3ujL6o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)