UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Kt8D4ZP7UUJJ0CHoxu38mVqCY5zUQYCYJnlkg5R7esw='
WHERE
key_id = 'b8aabe9a6c719f4de8a72a98bed7d0716b8ec71ed3653e4b9e07439569b31d5a'
AND (
token = 'Kt8D4ZP7UUJJ0CHoxu38mVqCY5zUQYCYJnlkg5R7esw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)