UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+V7g1f5ZWUiHVi6mUX8OiC9PbiPBI+rFl+YJWP24lO8='
WHERE
key_id = '5d31fb575801b65c503e99ae2fc4c959d13243583904deb8317931cd51936e4e'
AND (
token = '+V7g1f5ZWUiHVi6mUX8OiC9PbiPBI+rFl+YJWP24lO8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)