UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BjFuMZttwcZ9qeRZbTet0zeLYU3jI8PdNBsa3PU+wco='
WHERE
key_id = 'bb1076e6252caf541f9a7c9a4c25d03a2da032ae963fd6b176cfd8618ae62cc8'
AND (
token = 'BjFuMZttwcZ9qeRZbTet0zeLYU3jI8PdNBsa3PU+wco='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)